package com.shiikong_memory.yez.MySQLAPI.Dao;

import com.shiikong_memory.yez.MySQLAPI.JavaBean.SklandBean;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface SklandMapper {
    @Select("select * from skland")
    List<SklandBean> getAll();
    @Select("select * from skland where KookId=#{kookId}")
    SklandBean getByKookId(@Param("kookId") String kookId);
    @Insert("insert into skland(KookId, KookName, ArknightsToken, BotId)values(#{KookId},#{KookName},#{ArknightsToken},#{BotId})")
    boolean addSkland(@Param("KookId") String KookId, @Param("KookName") String KookName, @Param("ArknightsToken") String ArknightsToken, @Param("BotId") String BotId);
    @Update("update skland set ArknightsToken=#{ArknightsToken} where KookId=#{KookId}")
    boolean updateByKookId(@Param("KookId") String kookId, @Param("ArknightsToken") String ArknightsToken);
    @Delete("delete from skland where KookId=#{KookId}")
    boolean deleteByKookId(@Param("KookId") String KookId);
}
